<?php
//防止直接输地址进入
if (empty($_COOKIE['AdminId'])){
    echo "尚未登录,请先登录"."<br/>";
    echo "<a href='login.php'>登录</a>";
    exit();
}

//连接数据库
$dsn = "sqlsrv:Server=localhost;Database=Task";
$db = new PDO($dsn, "sa", "123456");

$sql = "select * from Task order by TaskId desc ";
$statement = $db ->query($sql);
$taskList = $statement ->fetchAll(PDO::FETCH_ASSOC);

$statusList = [
  1 => "新创建",
  2 => "进行中...",
  3 => "已完成"
];



?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>列表</title>
    <link rel="stylesheet" type="text/css" href="css/main.css" />
    <script src="js/jquery.js"></script>
</head>
<body>
<div id="container">
    <div id="login_info">
        欢迎你：<?php echo $_COOKIE['AdminAccount']; ?><!--获取从check过来的cookie-->
        <a href="loginOut.php">退出登录</a>
    </div>
    <div id="choose_div">
        <button id="all">全选</button>
        <a id="multi_delete" href="javascript:void(0);">删除选中任务</a>

        <a id="add" href="taskAdd.php" style="float: right">增加任务</a>
    </div>
    <form id="multi-delete-form" action="taskMultiDelete.php">
    <table class="list">
        <tbody>
        <tr>
            <th></th>
            <th>任务id</th>
            <th>任务名称</th>
            <th>任务状态</th>
            <th>创建时间</th>
            <th>修改时间</th>
            <th>操作</th>
        </tr>
        <?php foreach ($taskList as $item): ?>
        <tr>
            <td><input type="checkbox" class="task-checkbox" name="TaskId[]" value="<?php echo $item['TaskId'] ?>"></td>
            <td><?php echo $item['TaskId']; ?></td>
            <td><?php echo $item['TaskName']; ?></td>
            <td><?php echo $statusList[$item['TaskStatus']]; ?></td> <!--先获取status状态值-->
            <td><?php echo $item['TaskCreateTime']; ?></td>
            <td><?php echo $item['TaskUpdateTime']; ?></td>
            <td><!--直接在链接url后面用?id,可以get到-->
                <a class="detail" href="taskDetail.php?id=<?php echo $item['TaskId'] ?>">详情</a>
                <?php if ($item['TaskStatus'] == 1) : ?>
                <a class="delete" href="taskDelete.php?id=<?php echo $item['TaskId'] ?>">删除</a>
                <?php endif; ?>
            </td>
        </tr>
        <?php endforeach; ?>
        </tbody>
    </table>
    </form>
</div>

<script src="js/main.js">
</script>
</body>
</html>
